package manager.ikaraoke.database;

public class Constants {
	public static final int database_version  = 1;
	public static final String dbName = "ikaraoke";
	public static final String dbFoodDrink = "food";
	public static final String fieldName = "name";
	public static final String fieldCost = "cost";
	public static final String fieldType = "type";
	public static final String fieldId = "id";
	// create database
	public static final String dbCreateFood = "CREATE TABLE " + dbFoodDrink + " ( " + fieldId 
			+ " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, " + fieldName 
			+ " TEXT NOT NULL, " + fieldCost + "  FLOAT, " +fieldType+ " INTEGER NOT NULL )";
}
